<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateRechargeBusinTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('recharge_busin', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('user_id')->comment('用户id');
            $table->integer('recharge_fee')->comment('充值金额');
            $table->decimal('service_fee',16,2)->default(0.00)->comment('服务费');
            $table->decimal('actual_fee',16,2)->default(0.00)->comment('实付金额');
            $table->string('recharge_status',10)->comment('充值状态');
            $table->string('recharge_source',255)->comment('充值来源');
            $table->string('order_number',255)->comment('充值订单号');
            $table->string('recharge_mobile',255)->comment('充值手机号');
            $table->string('shop_feedback_number',255)->comment('支付商家反馈订单号');
            $table->integer('double_fee')->comment('翻贝金额');
            $table->string('city_id',100)->comment('城市id');
            $table->string('user_order_source',255)->default('')->comment('用户充值来源');
            $table->string('remark',255)->comment('充值备注');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::drop('recharge_busin');
    }
}
